How do you use the Office365.Groups.HttpRequest(URI, Method, file)

[Justin-GOV]

I would like to query Graph from PowerApps by providing a Group DisplayName or mailNickName.

Currently this works in Graph Explorer - https://graph.microsoft.com/v1.0/groups?$filter=mailNickname eq '<nickname>' but I can't find any documentation to use the Office365.Groups.HttpRequest("https://graph.microsoft.com/v1.0/groups?$filter=mailNickname eq '<nickname>'", "GET", file) to make it work.

What am I supposed to use for 'file'?

Where do I find information about how to structure the formula in PowerApps? I am trying to use instructions from this docs.microsoft.com page: Office 365 Groups - Connectors | Microsoft Docs

[johnxt]

I've been fighting this for nearly 2 solid days, many thanks to dotter for putting me on the right track. So here's how I did it, forget the image box you don't need that. Just generate yourself the proper string and put it into a variable, then send that to the httprequest. The reason why dotter's example code didnt work for you as typed is because of a slight error it should be "data:" not "data&colon;" (some kind of html decoding issue somewhere along the line I guess)

For testing, I made 2 buttons to quickly generate the required string then post it into a list on our sharepoint site. Button1.OnSelect:

Set(myJSONString, 
    "{""fields"":{""Title"":""John Smith""}}"
);
Set(myBinaryString,With({
    InputText:myJSONString,
    AsciiTable:AddColumns(Sequence(2^8,1),"char",Char(Value)),
    B64ToBin:
    Table(
        {b64:"A",bin:"000000"},
        {b64:"B",bin:"000001"},
        {b64:"C",bin:"000010"},
        {b64:"D",bin:"000011"},
        {b64:"E",bin:"000100"},
        {b64:"F",bin:"000101"},
        {b64:"G",bin:"000110"},
        {b64:"H",bin:"000111"},
        {b64:"I",bin:"001000"},
        {b64:"J",bin:"001001"},
        {b64:"K",bin:"001010"},
        {b64:"L",bin:"001011"},
        {b64:"M",bin:"001100"},
        {b64:"N",bin:"001101"},
        {b64:"O",bin:"001110"},
        {b64:"P",bin:"001111"},
        {b64:"Q",bin:"010000"},
        {b64:"R",bin:"010001"},
        {b64:"S",bin:"010010"},
        {b64:"T",bin:"010011"},
        {b64:"U",bin:"010100"},
        {b64:"V",bin:"010101"},
        {b64:"W",bin:"010110"},
        {b64:"X",bin:"010111"},
        {b64:"Y",bin:"011000"},
        {b64:"Z",bin:"011001"},
        {b64:"a",bin:"011010"},
        {b64:"b",bin:"011011"},
        {b64:"c",bin:"011100"},
        {b64:"d",bin:"011101"},
        {b64:"e",bin:"011110"},
        {b64:"f",bin:"011111"},
        {b64:"g",bin:"100000"},
        {b64:"h",bin:"100001"},
        {b64:"i",bin:"100010"},
        {b64:"j",bin:"100011"},
        {b64:"k",bin:"100100"},
        {b64:"l",bin:"100101"},
        {b64:"m",bin:"100110"},
        {b64:"n",bin:"100111"},
        {b64:"o",bin:"101000"},
        {b64:"p",bin:"101001"},
        {b64:"q",bin:"101010"},
        {b64:"r",bin:"101011"},
        {b64:"s",bin:"101100"},
        {b64:"t",bin:"101101"},
        {b64:"u",bin:"101110"},
        {b64:"v",bin:"101111"},
        {b64:"w",bin:"110000"},
        {b64:"x",bin:"110001"},
        {b64:"y",bin:"110010"},
        {b64:"z",bin:"110011"},
        {b64:"0",bin:"110100"},
        {b64:"1",bin:"110101"},
        {b64:"2",bin:"110110"},
        {b64:"3",bin:"110111"},
        {b64:"4",bin:"111000"},
        {b64:"5",bin:"111001"},
        {b64:"6",bin:"111010"},
        {b64:"7",bin:"111011"},
        {b64:"8",bin:"111100"},
        {b64:"9",bin:"111101"},
        {b64:"+",bin:"111110"},
        {b64:"/",bin:"111111"}
    )},
    With({
    BinRep:
    Concat(
        AddColumns(ForAll(Split(InputText,""), {Result: ThisRecord.Value}),"dec",LookUp(AsciiTable,char=Result).Value),//Convert text to Ascii character code (decimal)
        Concat(Sequence(8,8,-1),Text(If(And(Mod(dec,Power(2,Value))>=Power(2,Value-1),Mod(dec,Power(2,Value))<Power(2,Value)),1,0)))&"","")//Convert decimal to binary
    },
        With({b64string:Concat(
            Sequence(
                RoundUp(Len(BinRep)/6,0),0),
                LookUp(
                    B64ToBin,
                    bin=Mid(BinRep&Left("000000",6-Mod(Len(BinRep),6)),6*Value+1,6) //Left("000000"....) is padding right with zero
                ).b64&"", 
                ""
            )},
            b64string&Left("====",Mod(4-Mod(Len(b64string),4),4))//Convert binary to base64
        )
    )
));

Set(myGeneratedBlob,"data&colon;application/json;base64," & myBinaryString)

Button2.OnSelect:

Office365Groups.HttpRequest("https://graph.microsoft.com/v1.0/sites/<sharepoint site id>/lists/<sharepoint list id>/items","POST",myGeneratedBlob)

[johnxt]

Ha. Just look at that. Its also messed up my button1 code the same way it did with dotters, and inside a code block no less. what a great job Microsoft!

So the last line should be this, but without spaces:

Set(myGeneratedBlob,"data : application/json;base64," & myBinaryString)

[MRBCODC]

I am struggling with this I am using this to get the data i want 

Set(UserAzureAD,
Office365Groups.HttpRequest(
"

https://graph.microsoft.com/v1.0/users?$filter=userPrincipalName eq 'companyemail@company.com'&$select=id,displayName,userPrincipalName,onPremisesSamAccountName,jobTitle,officeLocation

",
"GET",
""
));

I can not use any of the data that comes back as it is an untypedobject

I can not see how to get in to a collection or table so i can use the data I mainly need the onpremsisisamaccountname as this seems to be the only way to get it.

[johnxt]

Hello there, I'm by no means an expert at this stuff as until yesterday I hadn't even touched graph before lol

But I did find this page on my travels trying to understand the httprequest POST function, hopefully it can be of some help:
Untyped object data type - Power Platform | Microsoft Learn

Also this one:
powerapps-docs/powerapps-docs/maker/canvas-apps/untyped-and-dynamic-objects.md at main · MicrosoftDo...

Good luck!

[MRBCODC]

Hi @johnxt 

thank you fir the response, yes i have seen this page and tried to use the part about arrays but it keeps giving me an error it expect array or table but actual is object

Thanks

[MRBCODC]

When trying to convert to a table using

ForAll( Table(UserAzureAD), { FirstField: Value(ThisRecord.Value.id), SecondField: Text(ThisRecord.Value.displayName) } )

i get below error

[johnxt]

Ok, so I've been hammering away at it. And the solution is so simple, and yet such a pain 😄

Text(First(UserAzureAD.value).onPremisesSamAccountName)

[johnxt]

so what it is, if you were running a query which returns a single result e.g:

Set(varResponse, Office365Groups.HttpRequest("https://graph.microsoft.com/v1.0/me","GET",""));

You could just use Text(varResponse.displayName) and be happy.

As you're running a query it returns an array of results (called 'value'), which you need to handle. Since in this case you're only returning 1 result you can just use First() to get it, if you wanted to return more you would handle it in your App the usual way ForAll() or whatever

[MRBCODC]

I just come to the same conclusion like you say so simple but a huge annoyance!

my next issue is I am trying to send a variable in the api url but it is not changing the text in the request url it is only sending the name of the variable

[MRBCODC]

Yes this was driving me insane as it was working with ME endpoint but the user wasn't working 
ForAll was not working for me either as I was going to run a generic query on for all users and store in a collection and do lookup to get the data i wanted but it don't seem like that is possible