PowerApps form not loading properly on DispForm.aspx / EditForm.aspx (Custom list forms)

I have a SharePoint list with customized list forms via PowerApps. Everything works fine if I launch the form from the list (in a dialog), but I also have emails that get sent by Power Automate, which include links to the Edit form (ex: <site url>/Lists/<listName>/EditForm.aspx?ID=17). After clicking the link, the correct data does not load – instead it loads the data for the “first” item in the list (ID = 1 if present, otherwise ID 2, etc). If i refresh the page then the correct data loads.

I added a label to the form to show the value of “SharePointIntegration.Selected.ID” and it shows the ID matching whatever is otherwise shown on the form (1 if not correct, otherwise the correct ID).

I’ve confirmed this issue on a “fresh” list and brand new custom list form, with no actual customizations other than adding labels to the form. This occurs on both Chrome and Edge. I’ve deleted the cache, cookies, etc. I have the same issue if I use the “Copy link” action and paste it into a new tab (ex: <urlToList>/DispForm.aspx?ID=17&pa=1&e=IygOpP)

json – type ‘List’ is not a subtype of type ‘Map’

Verán, soy nuevo en Flutter y la verdad no tengo muchos conocimientos sobre Flutter. En mi proyecto actual, me surge este problema: ‘type ‘List’ is not a subtype of type ‘Map<String, dynamic>”. La verdad no comprendo a que se debe el error, por favor seria de gran ayuda su cooperación. De antemano, muchas gracias.

Modelo LineTransport

import 'dart:convert';

class LineTransport {
    LineTransport({
        required this.lineas,
    });

    List<Linea> lineas;
    String? id;

    factory LineTransport.fromJson(String str) => LineTransport.fromMap(json.decode(str));

    String toJson() => json.encode(toMap());

    factory LineTransport.fromMap(Map<String, dynamic> json) => LineTransport(
        lineas: List<Linea>.from(json("Lineas").map((x) => Linea.fromMap(x))),
    );

    Map<String, dynamic> toMap() => {
        "Lineas": List<dynamic>.from(lineas.map((x) => x.toMap())),
    };
}
class Linea {
    Linea({
        required this.nombre,
        required this.calles,
        required this.zonasCbba,
        required this.rutas,
    });

    String nombre;
    List<String> calles;
    List<String> zonasCbba;
    List<Ruta> rutas;

    factory Linea.fromJson(String str) => Linea.fromMap(json.decode(str));

    String toJson() => json.encode(toMap());

    factory Linea.fromMap(Map<String, dynamic> json) => Linea(
        nombre: json("Nombre"),
        calles: List<String>.from(json("Calles").map((x) => x)),
        zonasCbba: List<String>.from(json("ZonasCBBA").map((x) => x)),
        rutas: List<Ruta>.from(json("Rutas").map((x) => Ruta.fromMap(x))),
    );

    Map<String, dynamic> toMap() => {
        "Nombre": nombre,
        "Calles": List<dynamic>.from(calles.map((x) => x)),
        "ZonasCBBA": List<dynamic>.from(zonasCbba.map((x) => x)),
        "Rutas": List<dynamic>.from(rutas.map((x) => x.toMap())),
    };
}
class Ruta {
    Ruta({
        required this.sentido,
    });

    String sentido;

    factory Ruta.fromJson(String str) => Ruta.fromMap(json.decode(str));

    String toJson() => json.encode(toMap());

    factory Ruta.fromMap(Map<String, dynamic> json) => Ruta(
        sentido: json("Sentido"),
    );

    Map<String, dynamic> toMap() => {
        "Sentido": sentido,
    };
}

Service LineTransportService
En este service es donde me ocurre el problema, lo podrán ver comentado

import 'dart:convert';
import 'package:componentes/models/linesTransport.dart';
import 'package:flutter/cupertino.dart';
import 'package:http/http.dart' as http;

class LineTransportService extends ChangeNotifier {

  final String _baseUrl = 'pruebalineas12-cddcf-default-rtdb.firebaseio.com';

  final List<LineTransport> lines = ();

  LineTransportService() { 
    this.loadLinesTransport();
  }

  Future loadLinesTransport() async {
    final url = Uri.https(_baseUrl, 'Lineas.json');
    final resp = await http.get(url);

    final Map<String, dynamic> linesMap = json.decode(resp.body); //AQUI ME SURGE EL ERROR

    linesMap.forEach((key, value) {
      final tempLine = LineTransport.fromMap(value);
      tempLine.id = key;
      this.lines.add(tempLine);
    });
    print(this.lines(0).lineas(0).nombre);
  }
}

Buenas. Verán, soy nuevo en Flutter y la verdad no tengo muchos conocimientos sobre Flutter. En mi proyecto actual, me surge este problema: ‘type ‘List’ is not a subtype of type ‘Map<String, dynamic>”. La verdad no comprendo a que se debe el error, por favor seria de gran ayuda su cooperación. De antemano, muchas gracias.

javascript – Build list of prefixes, including the whole string

There is a string “abcdebfkj”, we need to transform this string to the below array:

expected o/p:  

("a", "a.b", "a.b.c", "a.b.c.d", "a.b.c.d.e", "a.b.c.d.e.b", "a.b.c.d.e.b.f", "a.b.c.d.e.b.f.k", "a.b.c.d.e.b.f.k.j")

I am able to do that, but was looking for more promising solution if any. I did that in O(n) time complexity. Please let me know if the below can be improved in any way.

function splitString(str) {
  const result = ();
  for (let i = 0; i < str.length; i++) {
  i === 0 ? result.push(str(i)) : result.push(`${result(i-1)}.${str(i)}`);
  }
  return result;
}

console.log(splitString("abcdebfkj"))

How can I avoid checking the index and make the for loop work?

How to insert multiple URLs with a title for each URL in an SharePoint List Column?

I am trying to know if there is a way to insert multiple URLs and give a title to each URL in a column. For reference, please have a look at this below image.

enter image description here

In this list, we have Title, Name and ArtifactLink. The Name column has duplicate values, so may I know If there is a way like Name -> Agile, ArtifactLink -> Planning Poker Guidance with it’s URL and Project Startup with it’s URL.

Finding similar values within a list of lists in Python

I am working on a machine learning problem with object detection. For now, I am trying to find GPS coordinates that are close to other GPS coordinates. If they are close, I want to make note of it by index. So in my example below, with test data, these two areas are not actually close to one another, so their ‘close_points_index’ should be just their index. But my actual data set has ~100k observations.

This code is slow with 100k observations. I am looking for some help optimizing this code as I can get correct output but would like it if someone could point out any inefficiencies.

My data looks like:

({'area_name': 'ElephantRock', 'us_state': 'Colorado', 'url': 'https://www.mountainproject.com/area/105746486/elephant-rock', 'lnglat': (38.88463, -106.15182), 'metadata': {'lnglat_from_parent': False}}, {'area_name': 'RaspberryBoulders', 'us_state': 'Colorado', 'url': 'https://www.mountainproject.com/area/108289128/raspberry-boulders', 'lnglat': (39.491, -106.0501), 'metadata': {'lnglat_from_parent': False}})

My code solution is below. I avoided using two for loops but realize that I am sure a map() is just syntatical sugar for a for loop. Note that latLongDistance I assume is fairly optimized but if not I don’t mind. My focus is on my findClusters() function.

from math import cos, asin, sqrt, pi
from functools import partial

def latLongDistance(coord1, coord2):

    lat2 = coord2(0)
    lat1 = coord1(0)

    lon1 = coord1(1)
    lon2 = coord2(1)

    p = pi/180
    a = 0.5 - cos((lat2-lat1)*p)/2 + cos(lat1*p) * cos(lat2*p) * (1-cos((lon2-lon1)*p))/2

    kmDistance = 12742 * asin(sqrt(a)) 

    return kmDistance

def findClusters(listOfPoints, thresholdValueM = 800):

    coords = (x('lnglat') for x in listOfPoints)

    for index, data in enumerate(listOfPoints):
        
        lngLat = data('lnglat')

        modifiedLLDistance = partial(latLongDistance,coord2 = lngLat)
        
        listOfDistances = list(map(modifiedLLDistance,coords))

        meterDistance = (x*1000 for x in listOfDistances)

        closePoints = (i for i in range(len(meterDistance)) if meterDistance(i) < thresholdValueM)

        listOfPoints(index)('close_points_index') = closePoints


    return listOfPoints


After the function is ran, see below. Note that these have multiple indices as I ran this output on the actual data set. If I were to run just these two points their indices should be: (0) and (1) respectively.


({'area_name': 'ElephantRock', 'us_state': 'Colorado', 'url': 'https://www.mountainproject.com/area/105746486/elephant-rock', 'lnglat': (38.88463, -106.15182), 'metadata': {'lnglat_from_parent': False}, 'close_points_index': (0)}, {'area_name': 'RaspberryBoulders', 'us_state': 'Colorado', 'url': 'https://www.mountainproject.com/area/108289128/raspberry-boulders', 'lnglat': (39.491, -106.0501), 'metadata': {'lnglat_from_parent': False}, 'close_points_index': (1)})

I’ve experimented with a few things, but am coming up short. Primarily, I am a bit inexperienced with finding speed increases as I am relatively new to Python. Any critical input would be helpful. I have not posted here so let me know if I need some more information for it to be reproducible.

javascript – amount of divs relative to length of list

I’ve been working on a web project, and although I’m pretty familiar with HTML & CSS, I’m new to JavaScript. Here’s my current setup:

//in full setup, the var is stored as a seperate file, loaded first, to make the JSON more convenient to edit
var jsonList = 
{
    "first": {
        "Friendly": "Nest Mini (2nd gen)",
        "Model": "Google Nest Mini (2nd Generation)",
        "Manufacturer": "Google",
        "Type": "speaker",
        "Tech": (
            "wifi"
        ),
        "Software": (
            "Google Home"
        )
    }
};

document.getElementById("friendly").innerHTML = jsonList.first.Friendly;
document.getElementById("model").innerHTML = jsonList.first.Model;
document.getElementById("manufacturer").innerHTML = jsonList.first.Manufacturer;
document.getElementById("type").innerHTML = jsonList.first.Type;
document.getElementById("tech").innerHTML = jsonList.first.Tech;
document.getElementById("software").innerHTML = jsonList.first.Software;
#card {
    font-family: 'Roboto', sans-serif;
    vertical-align:top;
    border-radius:25px;
    background-color:white;
    box-shadow: 0 4px 8px 0 #0000002a, 0 6px 20px 0 #0000002a;
    position:relative;
    line-height:8px;
    height:150px;
    padding-left:150px /* normally an icon goes to the left */
}

#friendly {
    font-size:40px;
    padding-top:30px;
    line-height:0px
}
#model {
    opacity:40%;
    line-height:0px;
    padding-bottom:4px;
}
#type,#tech,#software {
    display:inline
}
    <div id="card">
        <p id="friendly"></p>
        <p id="model"></p>
        <p>Made by <span id="manufacturer"></span></p>
        <p id="type"></p>
        <p id="tech"></p> 
        <p id="software"></p>
    </div>
    

What I would like to do, is to be able to add a “second”, “third”, etc and have a relative amount of divs be made automatically. So for instance, if I had 3 entries in the JSON, I’d have 3 <div id="code">. (ideally, the values would be named “0001”, “0002” and so forth, but that seems to introduce new issues beyond the scope of this.)

Anyways, I’m wondering what the best way would be to go about this. When I looked into it, I saw you could append to lists in JS, and so maybe that would be the route to take, but I’m not sure. Hopefully someone with more experience in web technologies can point me in the right direction. Thanks!

custom post types – list articles in admin showing nested categories or slugs?

In the admin control panel where I can list articles it has a heading with Bulk Actions and then filters for All Dates, Article Categories, Article Tags. When you look at the drop down for Article Categories it’s only category names so you can’t tell which category it actually is when you have many nested categories with the same name. For example, several products with a FAQ sub-category, but when listed you just see a bunch of FAQ (n) entries.

Is there a way to have it list the categories showing the tree or maybe using the slug which would also differentiate between them all?

Thanks!

SharePoint Online, List Web Part’s Query Receives Incorrect Results

sorry if this has been asked already, i’m not quite sure how to word the question. and i’ll try to explain as best as i can what is happening.

we have a List called “News and Alerts”. there is a column called “TopStoryYN” that is configured to the “Yes/No (check box)” form type.

on our home page, there is a Web Part for the “News and Alerts” list. the “Display Templates” has the “Control” drop down selected on “Rotator”.

the “Search Criteria” has a query configured that does this:

path:”(site)/Lists/NewsandAlerts” TopStoryYNOWSBOOL=1

but when i use “Test query”, it returns 10 results. but only 2 of those actually have “TopStoryYN” checked, the other 8 all have “TopStoryYN” unchecked. but there’s a 3rd result that doesn’t even come up.

the query settings have the “Caching” option set to “No caching”.

i have tried to take one of the 8 incorrect results, check the box so it is a valid result, save, uncheck the box, save. but it still comes up in the query results.

originally, the query was returning 16 results. but i am not sure what i did to make 6 of those results disappear. i went through every incorrect result and made an edit to each of them to see if that would make them get removed. but i guess that only worked 6 times?

i’m not sure what else to try.

(edit) forgot to mention that this was working originally. and from my knowledge, nothing was changed. just all of a sudden, the incorrect results were being retrieved.

What is the maximum syntax formulas that I can use in calculated column on my Sharepoint list?

I have created 20 syntax formulas (IF(AND((Job Group)=) based upon two other columns on my calculated column field, but I seemed to have reached a maximum limit.

I cannot load my 21st syntax formula as it immediately gives me an error message. Is there a way around this?

SharePoint List customized in PowerApps : Automatically change value of dropdown column based on selection in another dropdown

I’m new to SharePoint and PowerApps, can you help me on this one on how to resolve this issue?

I have my SharePoint list customized through PowerApps.

These are the dropdown columns that were set to automatically change value based on selection of one another.

BOG Disposition
Encoder’s Disposition
The scenario are the following below.

If BOG Disposition is equal to “Return (For Checking)” then the value of Encoder’s Disposition will automatically change to “Awaiting User’s Response” – This scenario is okay and working fine both for SharePoint and PowerApps but the problem is the second scenario.

Once the value of Encoder’s Disposition was now changed into “User’s Responded”, BOG Disposition must be changed into “Pending”. However, there is an error on formula saying “This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value”

I tried resetting the value of BOG Disposition but still not working.